
<title>数据库管理</title>

<div class="layui-card layadmin-header">
  <div class="layui-breadcrumb" lay-filter="breadcrumb">
    <a lay-href="">数据库管理</a>
    <a><cite>库列表</cite></a>
  </div>
</div>


<div class="layui-fluid">
  <div class="layui-card">
<!--    表头上的搜索区域-->
    <div class="layui-form layui-card-header layuiadmin-card-header-auto" lay-filter="layadmin-userfront-formlist">
      <div class="layui-form-item">
        <div class="layui-inline">
          <label class="layui-form-label">主机名</label>
          <div class="layui-input-block">
            <input type="text" name="hostname" placeholder="请输入" autocomplete="off" class="layui-input">
          </div>
        </div>
<!--        (太麻烦没做)-->
<!--        <div class="layui-inline">-->
<!--          <label class="layui-form-label">连接状态</label>-->
<!--          <div class="layui-input-block">-->
<!--            <select name="connect">-->
<!--              <option value="">不限</option>-->
<!--              <option value="true">连接</option>-->
<!--              <option value="false">断开</option>-->
<!--            </select>-->
<!--          </div>-->
<!--        </div>-->
<!--        搜索按钮-->
        <div class="layui-inline">
          <button class="layui-btn layuiadmin-btn-useradmin" lay-submit lay-filter="LAY-user-front-search">
            <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
          </button>
        </div>
      </div>
    </div>
<!-- 表头按钮-->
    <div class="layui-card-body">
      <div style="padding-bottom: 10px;">
        <button class="layui-btn layuiadmin-btn-useradmin" data-type="batchdel">删除</button>
        <button class="layui-btn layuiadmin-btn-useradmin" data-type="add">添加</button>
      </div>
<!--  表格主体-->
      <table id="LAY-db-link" lay-filter="LAY-db-link"></table>
<!--     功能区按钮-->
      <script type="text/html" id="table-useradmin-webuser">
        <a class="layui-btn layui-btn-normal layui-btn-xs" lay-event="edit"><i class="layui-icon layui-icon-edit"></i>编辑</a>
        <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del"><i class="layui-icon layui-icon-delete"></i>删除</a>
      </script>
      <script type="text/html" id="connectionStatus">

        <input type="checkbox"  {{= d.connect===true?'checked':''  }} data-id="{{ d.id }}" name="connect" lay-skin="switch" lay-filter="component-form-switchTest" lay-text="连接|断开">
        <a class="layui-btn layui-btn-normal layui-btn-xs {{= d.connect===true?'':'layui-hide'  }} " lay-event="look"><i class="layui-icon layui-icon-table"></i>查看详情</a>
      </script>
    </div>
  </div>
</div>


<script>
  layui.use('syslink', layui.factory('syslink')).use(['admin', 'syslink', 'table'], function(){
    var $ = layui.$
            ,admin = layui.admin
            ,view = layui.view
            ,table = layui.table
            ,form = layui.form;

    form.render(null, 'layadmin-userfront-formlist');

    //监听搜索
    form.on('submit(LAY-user-front-search)', function(data){
      var field = data.field;

      //执行重载
      table.reload('LAY-db-link', {
        where: field
      });
    });

    //事件
    var active = {
      batchdel: function(){
        var checkStatus = table.checkStatus('LAY-db-link')
                ,checkData = checkStatus.data; //得到选中的数据

        if(checkData.length === 0){
          return layer.msg('请选择数据');
        }
        var arr=new Array();
        for (var i=0; i<checkData.length;i++ ){
          arr.push(checkData[i].id)
        }
        layer.confirm('确定删除吗？', function(index) {
          //执行 Ajax 后重载
          admin.req({
            type: 'delete',
            url: 'dataSource',
            traditional: true,
            data:{"idList":arr},
            success: function (data) {
              layer.msg(data.msg);
              layui.table.reload('LAY-db-link'); //重载表格
              // layer.msg('已删除');
            }
          })
          // layer.msg('已删除');
        });
      }
      ,add: function(){
        admin.popup({
          title: '添加用户'
          ,area: ['500px', '450px']
          ,id: 'LAY-popup-dblink-add'
          ,success: function(layero, index){
            view(this.id).render('dbLink/dblinkform').done(function(){
              form.render(null, 'layuiadmin-form-dblink');
              //监听提交
              form.on('submit(LAY-dblink-front-submit)', function(data){
                var field = data.field; //获取提交的字段

                //提交 Ajax 成功后，关闭当前弹层并重载表格
                // $.ajax({});
                admin.req({
                  type: 'POST',
                  url: 'dataSource',
                  data: field,
                  success: function (data) {
                    layer.msg(data.msg);
                    layui.table.reload('LAY-db-link'); //重载表格
                  }
                });
                layer.close(index); //执行关闭
              });
            });
          }
        });
      }
    };

    $('.layui-btn.layuiadmin-btn-useradmin').on('click', function(){
      var type = $(this).data('type');
      active[type] ? active[type].call(this) : '';
    });
  });
</script>